# -*- encoding:utf-8 -*-
import openpyxl
import os
import re
from pathlib import Path

from openpyxl import Workbook
from openpyxl.drawing.image import Image
from openpyxl.utils import get_column_letter
from PIL import Image as PILImage

# 读取的excel
workbook1 = openpyxl.load_workbook('C:\\Users\\VV\\Desktop\\5\\1.xlsx')
sheet1 = workbook1['Students']

# 写入的excel
workbook2 = openpyxl.load_workbook('C:\\Users\\VV\\Desktop\\5\\2.xlsx')
sheet2 = workbook2['Sheet1']

stu_year = {}
for row in sheet1.iter_rows(min_row=2, min_col=1, max_row=661, max_col=13):

    cell_value_id = row[0].value


